package com.game.majiang.vo;

import java.sql.SQLException;
import java.util.HashMap;

import javax.sql.rowset.CachedRowSet;

import com.game.server.db.SqlHelper;

import lombok.Data;
import lombok.extern.log4j.Log4j;

@Log4j
@Data
public class chexuanjiangchiVo {
	public static HashMap<String,String> getList() {
		HashMap<String,String> map = new HashMap<String,String>();
		String sql = "select name,val from chexuanjiangchi";
		CachedRowSet rs = SqlHelper.getResultSet(sql);
		try {
			while (rs.next()) 
			{  
				String key  = rs.getString(1);
				String value  = rs.getString(2);
				map.put(key, value);
			}
		} catch (SQLException e) {
			e.printStackTrace();
			log.warn("Sql:" + sql + "错误");
		}
		return map;
	}
}
